﻿<?xml version="1.0" encoding="utf-8"?>
<xs:schema id="dsSMSMonthly" targetNamespace="http://tempuri.org/dsSMSMonthly.xsd" xmlns:mstns="http://tempuri.org/dsSMSMonthly.xsd" xmlns="http://tempuri.org/dsSMSMonthly.xsd" xmlns:xs="http://www.w3.org/2001/XMLSchema" xmlns:msdata="urn:schemas-microsoft-com:xml-msdata" xmlns:msprop="urn:schemas-microsoft-com:xml-msprop" attributeFormDefault="qualified" elementFormDefault="qualified">
  <xs:annotation>
    <xs:appinfo source="urn:schemas-microsoft-com:xml-msdatasource">
      <DataSource DefaultConnectionIndex="0" FunctionsComponentName="QueriesTableAdapter" Modifier="AutoLayout, AnsiClass, Class, Public" SchemaSerializationMode="IncludeSchema" xmlns="urn:schemas-microsoft-com:xml-msdatasource">
        <Connections>
          <Connection AppSettingsObjectName="Web.config" AppSettingsPropertyName="CarlsbergConnectionString" ConnectionStringObject="" IsAppSettingsProperty="true" Modifier="Assembly" Name="CarlsbergConnectionString (Web.config)" ParameterPrefix="@" PropertyReference="AppConfig.System.Configuration.ConfigurationManager.0.ConnectionStrings.CarlsbergConnectionString.ConnectionString" Provider="System.Data.SqlClient" />
        </Connections>
        <Tables>
          <TableAdapter BaseClass="System.ComponentModel.Component" DataAccessorModifier="AutoLayout, AnsiClass, Class, Public" DataAccessorName="ReportSMSMonthlyTableAdapter" GeneratorDataComponentClassName="ReportSMSMonthlyTableAdapter" Name="ReportSMSMonthly" UserDataComponentName="ReportSMSMonthlyTableAdapter">
            <MainSource>
              <DbSource ConnectionRef="CarlsbergConnectionString (Web.config)" DbObjectName="Carlsberg.dbo.ReportSMSMonthly" DbObjectType="Table" FillMethodModifier="Public" FillMethodName="Fill" GenerateMethods="Both" GenerateShortCommands="true" GeneratorGetMethodName="GetData" GeneratorSourceName="Fill" GetMethodModifier="Public" GetMethodName="GetData" QueryType="Rowset" ScalarCallRetval="System.Object, mscorlib, Version=4.0.0.0, Culture=neutral, PublicKeyToken=b77a5c561934e089" UseOptimisticConcurrency="false" UserGetMethodName="GetData" UserSourceName="Fill">
                <InsertCommand>
                  <DbCommand CommandType="Text" ModifiedByUser="false">
                    <CommandText>INSERT INTO [ReportSMSMonthly] ([STT], [Code], [CodeNS], [Name], [BAGroup], [Phone], [BASCode], [BASName], [ProfileStatus], [TaxCode], [DOB], [DOBD], [DOBM], [DOBY], [Folk], [Nationality], [ResidentAddress], [IDCard], [IDDate], [IDDateD], [IDDateM], [IDDateY], [IDProvideBy], [BAStatus], [InDate], [InDateD], [InDateM], [InDateY], [OutDate], [OutDateD], [OutDateM], [OutDateY], [StartContractDate], [StartCDateD], [StartCDateM], [StartCDateY], [EndContractDate], [EndCDateD], [EndCDateM], [EndCDateY], [ContractType], [AccountNumber], [Bank], [OutletSMSCode], [OutletDragonCode], [Brand], [OutletName], [OutletAddress], [Location], [Province], [CVTCSR], [ASM], [WorkingHour], [DayOff], [Note], [NoOfDay], [CB], [CC], [CD], [D4], [DC], [GB], [GC], [H3], [H4], [HC]) VALUES (@STT, @Code, @CodeNS, @Name, @BAGroup, @Phone, @BASCode, @BASName, @ProfileStatus, @TaxCode, @DOB, @DOBD, @DOBM, @DOBY, @Folk, @Nationality, @ResidentAddress, @IDCard, @IDDate, @IDDateD, @IDDateM, @IDDateY, @IDProvideBy, @BAStatus, @InDate, @InDateD, @InDateM, @InDateY, @OutDate, @OutDateD, @OutDateM, @OutDateY, @StartContractDate, @StartCDateD, @StartCDateM, @StartCDateY, @EndContractDate, @EndCDateD, @EndCDateM, @EndCDateY, @ContractType, @AccountNumber, @Bank, @OutletSMSCode, @OutletDragonCode, @Brand, @OutletName, @OutletAddress, @Location, @Province, @CVTCSR, @ASM, @WorkingHour, @DayOff, @Note, @NoOfDay, @CB, @CC, @CD, @D4, @DC, @GB, @GC, @H3, @H4, @HC)</CommandText>
                    <Parameters>
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="Int32" Direction="Input" ParameterName="@STT" Precision="0" ProviderType="Int" Scale="0" Size="0" SourceColumn="STT" SourceColumnNullMapping="false" SourceVersion="Current" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="Int32" Direction="Input" ParameterName="@Code" Precision="0" ProviderType="Int" Scale="0" Size="0" SourceColumn="Code" SourceColumnNullMapping="false" SourceVersion="Current" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="String" Direction="Input" ParameterName="@CodeNS" Precision="0" ProviderType="NVarChar" Scale="0" Size="0" SourceColumn="CodeNS" SourceColumnNullMapping="false" SourceVersion="Current" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="String" Direction="Input" ParameterName="@Name" Precision="0" ProviderType="NVarChar" Scale="0" Size="0" SourceColumn="Name" SourceColumnNullMapping="false" SourceVersion="Current" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="String" Direction="Input" ParameterName="@BAGroup" Precision="0" ProviderType="NVarChar" Scale="0" Size="0" SourceColumn="BAGroup" SourceColumnNullMapping="false" SourceVersion="Current" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="String" Direction="Input" ParameterName="@Phone" Precision="0" ProviderType="NVarChar" Scale="0" Size="0" SourceColumn="Phone" SourceColumnNullMapping="false" SourceVersion="Current" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="String" Direction="Input" ParameterName="@BASCode" Precision="0" ProviderType="NVarChar" Scale="0" Size="0" SourceColumn="BASCode" SourceColumnNullMapping="false" SourceVersion="Current" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="String" Direction="Input" ParameterName="@BASName" Precision="0" ProviderType="NVarChar" Scale="0" Size="0" SourceColumn="BASName" SourceColumnNullMapping="false" SourceVersion="Current" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="String" Direction="Input" ParameterName="@ProfileStatus" Precision="0" ProviderType="NVarChar" Scale="0" Size="0" SourceColumn="ProfileStatus" SourceColumnNullMapping="false" SourceVersion="Current" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="String" Direction="Input" ParameterName="@TaxCode" Precision="0" ProviderType="NVarChar" Scale="0" Size="0" SourceColumn="TaxCode" SourceColumnNullMapping="false" SourceVersion="Current" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="Date" Direction="Input" ParameterName="@DOB" Precision="0" ProviderType="Date" Scale="0" Size="0" SourceColumn="DOB" SourceColumnNullMapping="false" SourceVersion="Current" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="Int32" Direction="Input" ParameterName="@DOBD" Precision="0" ProviderType="Int" Scale="0" Size="0" SourceColumn="DOBD" SourceColumnNullMapping="false" SourceVersion="Current" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="Int32" Direction="Input" ParameterName="@DOBM" Precision="0" ProviderType="Int" Scale="0" Size="0" SourceColumn="DOBM" SourceColumnNullMapping="false" SourceVersion="Current" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="Int32" Direction="Input" ParameterName="@DOBY" Precision="0" ProviderType="Int" Scale="0" Size="0" SourceColumn="DOBY" SourceColumnNullMapping="false" SourceVersion="Current" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="String" Direction="Input" ParameterName="@Folk" Precision="0" ProviderType="NVarChar" Scale="0" Size="0" SourceColumn="Folk" SourceColumnNullMapping="false" SourceVersion="Current" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="String" Direction="Input" ParameterName="@Nationality" Precision="0" ProviderType="NVarChar" Scale="0" Size="0" SourceColumn="Nationality" SourceColumnNullMapping="false" SourceVersion="Current" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="String" Direction="Input" ParameterName="@ResidentAddress" Precision="0" ProviderType="NVarChar" Scale="0" Size="0" SourceColumn="ResidentAddress" SourceColumnNullMapping="false" SourceVersion="Current" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="String" Direction="Input" ParameterName="@IDCard" Precision="0" ProviderType="NVarChar" Scale="0" Size="0" SourceColumn="IDCard" SourceColumnNullMapping="false" SourceVersion="Current" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="Date" Direction="Input" ParameterName="@IDDate" Precision="0" ProviderType="Date" Scale="0" Size="0" SourceColumn="IDDate" SourceColumnNullMapping="false" SourceVersion="Current" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="Int32" Direction="Input" ParameterName="@IDDateD" Precision="0" ProviderType="Int" Scale="0" Size="0" SourceColumn="IDDateD" SourceColumnNullMapping="false" SourceVersion="Current" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="Int32" Direction="Input" ParameterName="@IDDateM" Precision="0" ProviderType="Int" Scale="0" Size="0" SourceColumn="IDDateM" SourceColumnNullMapping="false" SourceVersion="Current" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="Int32" Direction="Input" ParameterName="@IDDateY" Precision="0" ProviderType="Int" Scale="0" Size="0" SourceColumn="IDDateY" SourceColumnNullMapping="false" SourceVersion="Current" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="String" Direction="Input" ParameterName="@IDProvideBy" Precision="0" ProviderType="NVarChar" Scale="0" Size="0" SourceColumn="IDProvideBy" SourceColumnNullMapping="false" SourceVersion="Current" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="String" Direction="Input" ParameterName="@BAStatus" Precision="0" ProviderType="NVarChar" Scale="0" Size="0" SourceColumn="BAStatus" SourceColumnNullMapping="false" SourceVersion="Current" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="Date" Direction="Input" ParameterName="@InDate" Precision="0" ProviderType="Date" Scale="0" Size="0" SourceColumn="InDate" SourceColumnNullMapping="false" SourceVersion="Current" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="Int32" Direction="Input" ParameterName="@InDateD" Precision="0" ProviderType="Int" Scale="0" Size="0" SourceColumn="InDateD" SourceColumnNullMapping="false" SourceVersion="Current" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="Int32" Direction="Input" ParameterName="@InDateM" Precision="0" ProviderType="Int" Scale="0" Size="0" SourceColumn="InDateM" SourceColumnNullMapping="false" SourceVersion="Current" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="Int32" Direction="Input" ParameterName="@InDateY" Precision="0" ProviderType="Int" Scale="0" Size="0" SourceColumn="InDateY" SourceColumnNullMapping="false" SourceVersion="Current" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="Date" Direction="Input" ParameterName="@OutDate" Precision="0" ProviderType="Date" Scale="0" Size="0" SourceColumn="OutDate" SourceColumnNullMapping="false" SourceVersion="Current" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="Int32" Direction="Input" ParameterName="@OutDateD" Precision="0" ProviderType="Int" Scale="0" Size="0" SourceColumn="OutDateD" SourceColumnNullMapping="false" SourceVersion="Current" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="Int32" Direction="Input" ParameterName="@OutDateM" Precision="0" ProviderType="Int" Scale="0" Size="0" SourceColumn="OutDateM" SourceColumnNullMapping="false" SourceVersion="Current" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="Int32" Direction="Input" ParameterName="@OutDateY" Precision="0" ProviderType="Int" Scale="0" Size="0" SourceColumn="OutDateY" SourceColumnNullMapping="false" SourceVersion="Current" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="Date" Direction="Input" ParameterName="@StartContractDate" Precision="0" ProviderType="Date" Scale="0" Size="0" SourceColumn="StartContractDate" SourceColumnNullMapping="false" SourceVersion="Current" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="Int32" Direction="Input" ParameterName="@StartCDateD" Precision="0" ProviderType="Int" Scale="0" Size="0" SourceColumn="StartCDateD" SourceColumnNullMapping="false" SourceVersion="Current" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="Int32" Direction="Input" ParameterName="@StartCDateM" Precision="0" ProviderType="Int" Scale="0" Size="0" SourceColumn="StartCDateM" SourceColumnNullMapping="false" SourceVersion="Current" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="StringFixedLength" Direction="Input" ParameterName="@StartCDateY" Precision="0" ProviderType="NChar" Scale="0" Size="0" SourceColumn="StartCDateY" SourceColumnNullMapping="false" SourceVersion="Current" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="Date" Direction="Input" ParameterName="@EndContractDate" Precision="0" ProviderType="Date" Scale="0" Size="0" SourceColumn="EndContractDate" SourceColumnNullMapping="false" SourceVersion="Current" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="Int32" Direction="Input" ParameterName="@EndCDateD" Precision="0" ProviderType="Int" Scale="0" Size="0" SourceColumn="EndCDateD" SourceColumnNullMapping="false" SourceVersion="Current" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="Int32" Direction="Input" ParameterName="@EndCDateM" Precision="0" ProviderType="Int" Scale="0" Size="0" SourceColumn="EndCDateM" SourceColumnNullMapping="false" SourceVersion="Current" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="Int32" Direction="Input" ParameterName="@EndCDateY" Precision="0" ProviderType="Int" Scale="0" Size="0" SourceColumn="EndCDateY" SourceColumnNullMapping="false" SourceVersion="Current" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="String" Direction="Input" ParameterName="@ContractType" Precision="0" ProviderType="NVarChar" Scale="0" Size="0" SourceColumn="ContractType" SourceColumnNullMapping="false" SourceVersion="Current" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="String" Direction="Input" ParameterName="@AccountNumber" Precision="0" ProviderType="NVarChar" Scale="0" Size="0" SourceColumn="AccountNumber" SourceColumnNullMapping="false" SourceVersion="Current" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="String" Direction="Input" ParameterName="@Bank" Precision="0" ProviderType="NVarChar" Scale="0" Size="0" SourceColumn="Bank" SourceColumnNullMapping="false" SourceVersion="Current" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="String" Direction="Input" ParameterName="@OutletSMSCode" Precision="0" ProviderType="NVarChar" Scale="0" Size="0" SourceColumn="OutletSMSCode" SourceColumnNullMapping="false" SourceVersion="Current" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="String" Direction="Input" ParameterName="@OutletDragonCode" Precision="0" ProviderType="NVarChar" Scale="0" Size="0" SourceColumn="OutletDragonCode" SourceColumnNullMapping="false" SourceVersion="Current" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="String" Direction="Input" ParameterName="@Brand" Precision="0" ProviderType="NVarChar" Scale="0" Size="0" SourceColumn="Brand" SourceColumnNullMapping="false" SourceVersion="Current" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="String" Direction="Input" ParameterName="@OutletName" Precision="0" ProviderType="NVarChar" Scale="0" Size="0" SourceColumn="OutletName" SourceColumnNullMapping="false" SourceVersion="Current" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="String" Direction="Input" ParameterName="@OutletAddress" Precision="0" ProviderType="NVarChar" Scale="0" Size="0" SourceColumn="OutletAddress" SourceColumnNullMapping="false" SourceVersion="Current" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="String" Direction="Input" ParameterName="@Location" Precision="0" ProviderType="NVarChar" Scale="0" Size="0" SourceColumn="Location" SourceColumnNullMapping="false" SourceVersion="Current" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="String" Direction="Input" ParameterName="@Province" Precision="0" ProviderType="NVarChar" Scale="0" Size="0" SourceColumn="Province" SourceColumnNullMapping="false" SourceVersion="Current" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="String" Direction="Input" ParameterName="@CVTCSR" Precision="0" ProviderType="NVarChar" Scale="0" Size="0" SourceColumn="CVTCSR" SourceColumnNullMapping="false" SourceVersion="Current" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="String" Direction="Input" ParameterName="@ASM" Precision="0" ProviderType="NVarChar" Scale="0" Size="0" SourceColumn="ASM" SourceColumnNullMapping="false" SourceVersion="Current" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="String" Direction="Input" ParameterName="@WorkingHour" Precision="0" ProviderType="NVarChar" Scale="0" Size="0" SourceColumn="WorkingHour" SourceColumnNullMapping="false" SourceVersion="Current" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="String" Direction="Input" ParameterName="@DayOff" Precision="0" ProviderType="NVarChar" Scale="0" Size="0" SourceColumn="DayOff" SourceColumnNullMapping="false" SourceVersion="Current" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="String" Direction="Input" ParameterName="@Note" Precision="0" ProviderType="NVarChar" Scale="0" Size="0" SourceColumn="Note" SourceColumnNullMapping="false" SourceVersion="Current" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="Int32" Direction="Input" ParameterName="@NoOfDay" Precision="0" ProviderType="Int" Scale="0" Size="0" SourceColumn="NoOfDay" SourceColumnNullMapping="false" SourceVersion="Current" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="Int32" Direction="Input" ParameterName="@CB" Precision="0" ProviderType="Int" Scale="0" Size="0" SourceColumn="CB" SourceColumnNullMapping="false" SourceVersion="Current" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="Int32" Direction="Input" ParameterName="@CC" Precision="0" ProviderType="Int" Scale="0" Size="0" SourceColumn="CC" SourceColumnNullMapping="false" SourceVersion="Current" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="Int32" Direction="Input" ParameterName="@CD" Precision="0" ProviderType="Int" Scale="0" Size="0" SourceColumn="CD" SourceColumnNullMapping="false" SourceVersion="Current" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="Int32" Direction="Input" ParameterName="@D4" Precision="0" ProviderType="Int" Scale="0" Size="0" SourceColumn="D4" SourceColumnNullMapping="false" SourceVersion="Current" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="Int32" Direction="Input" ParameterName="@DC" Precision="0" ProviderType="Int" Scale="0" Size="0" SourceColumn="DC" SourceColumnNullMapping="false" SourceVersion="Current" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="Int32" Direction="Input" ParameterName="@GB" Precision="0" ProviderType="Int" Scale="0" Size="0" SourceColumn="GB" SourceColumnNullMapping="false" SourceVersion="Current" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="Int32" Direction="Input" ParameterName="@GC" Precision="0" ProviderType="Int" Scale="0" Size="0" SourceColumn="GC" SourceColumnNullMapping="false" SourceVersion="Current" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="Int32" Direction="Input" ParameterName="@H3" Precision="0" ProviderType="Int" Scale="0" Size="0" SourceColumn="H3" SourceColumnNullMapping="false" SourceVersion="Current" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="Int32" Direction="Input" ParameterName="@H4" Precision="0" ProviderType="Int" Scale="0" Size="0" SourceColumn="H4" SourceColumnNullMapping="false" SourceVersion="Current" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="Int32" Direction="Input" ParameterName="@HC" Precision="0" ProviderType="Int" Scale="0" Size="0" SourceColumn="HC" SourceColumnNullMapping="false" SourceVersion="Current" />
                    </Parameters>
                  </DbCommand>
                </InsertCommand>
                <SelectCommand>
                  <DbCommand CommandType="Text" ModifiedByUser="true">
                    <CommandText>SELECT        ReportSMSMonthly.*
FROM            ReportSMSMonthly</CommandText>
                    <Parameters />
                  </DbCommand>
                </SelectCommand>
              </DbSource>
            </MainSource>
            <Mappings>
              <Mapping SourceColumn="STT" DataSetColumn="STT" />
              <Mapping SourceColumn="Code" DataSetColumn="Code" />
              <Mapping SourceColumn="CodeNS" DataSetColumn="CodeNS" />
              <Mapping SourceColumn="Name" DataSetColumn="Name" />
              <Mapping SourceColumn="BAGroup" DataSetColumn="BAGroup" />
              <Mapping SourceColumn="Phone" DataSetColumn="Phone" />
              <Mapping SourceColumn="BASCode" DataSetColumn="BASCode" />
              <Mapping SourceColumn="BASName" DataSetColumn="BASName" />
              <Mapping SourceColumn="ProfileStatus" DataSetColumn="ProfileStatus" />
              <Mapping SourceColumn="TaxCode" DataSetColumn="TaxCode" />
              <Mapping SourceColumn="DOB" DataSetColumn="DOB" />
              <Mapping SourceColumn="DOBD" DataSetColumn="DOBD" />
              <Mapping SourceColumn="DOBM" DataSetColumn="DOBM" />
              <Mapping SourceColumn="DOBY" DataSetColumn="DOBY" />
              <Mapping SourceColumn="Folk" DataSetColumn="Folk" />
              <Mapping SourceColumn="Nationality" DataSetColumn="Nationality" />
              <Mapping SourceColumn="ResidentAddress" DataSetColumn="ResidentAddress" />
              <Mapping SourceColumn="IDCard" DataSetColumn="IDCard" />
              <Mapping SourceColumn="IDDate" DataSetColumn="IDDate" />
              <Mapping SourceColumn="IDDateD" DataSetColumn="IDDateD" />
              <Mapping SourceColumn="IDDateM" DataSetColumn="IDDateM" />
              <Mapping SourceColumn="IDDateY" DataSetColumn="IDDateY" />
              <Mapping SourceColumn="IDProvideBy" DataSetColumn="IDProvideBy" />
              <Mapping SourceColumn="BAStatus" DataSetColumn="BAStatus" />
              <Mapping SourceColumn="InDate" DataSetColumn="InDate" />
              <Mapping SourceColumn="InDateD" DataSetColumn="InDateD" />
              <Mapping SourceColumn="InDateM" DataSetColumn="InDateM" />
              <Mapping SourceColumn="InDateY" DataSetColumn="InDateY" />
              <Mapping SourceColumn="OutDate" DataSetColumn="OutDate" />
              <Mapping SourceColumn="OutDateD" DataSetColumn="OutDateD" />
              <Mapping SourceColumn="OutDateM" DataSetColumn="OutDateM" />
              <Mapping SourceColumn="OutDateY" DataSetColumn="OutDateY" />
              <Mapping SourceColumn="StartContractDate" DataSetColumn="StartContractDate" />
              <Mapping SourceColumn="StartCDateD" DataSetColumn="StartCDateD" />
              <Mapping SourceColumn="StartCDateM" DataSetColumn="StartCDateM" />
              <Mapping SourceColumn="StartCDateY" DataSetColumn="StartCDateY" />
              <Mapping SourceColumn="EndContractDate" DataSetColumn="EndContractDate" />
              <Mapping SourceColumn="EndCDateD" DataSetColumn="EndCDateD" />
              <Mapping SourceColumn="EndCDateM" DataSetColumn="EndCDateM" />
              <Mapping SourceColumn="EndCDateY" DataSetColumn="EndCDateY" />
              <Mapping SourceColumn="ContractType" DataSetColumn="ContractType" />
              <Mapping SourceColumn="AccountNumber" DataSetColumn="AccountNumber" />
              <Mapping SourceColumn="Bank" DataSetColumn="Bank" />
              <Mapping SourceColumn="OutletSMSCode" DataSetColumn="OutletSMSCode" />
              <Mapping SourceColumn="OutletDragonCode" DataSetColumn="OutletDragonCode" />
              <Mapping SourceColumn="Brand" DataSetColumn="Brand" />
              <Mapping SourceColumn="OutletName" DataSetColumn="OutletName" />
              <Mapping SourceColumn="OutletAddress" DataSetColumn="OutletAddress" />
              <Mapping SourceColumn="Location" DataSetColumn="Location" />
              <Mapping SourceColumn="Province" DataSetColumn="Province" />
              <Mapping SourceColumn="CVTCSR" DataSetColumn="CVTCSR" />
              <Mapping SourceColumn="ASM" DataSetColumn="ASM" />
              <Mapping SourceColumn="WorkingHour" DataSetColumn="WorkingHour" />
              <Mapping SourceColumn="DayOff" DataSetColumn="DayOff" />
              <Mapping SourceColumn="Note" DataSetColumn="Note" />
              <Mapping SourceColumn="NoOfDay" DataSetColumn="NoOfDay" />
              <Mapping SourceColumn="CB" DataSetColumn="CB" />
              <Mapping SourceColumn="CC" DataSetColumn="CC" />
              <Mapping SourceColumn="CD" DataSetColumn="CD" />
              <Mapping SourceColumn="D4" DataSetColumn="D4" />
              <Mapping SourceColumn="DC" DataSetColumn="DC" />
              <Mapping SourceColumn="GB" DataSetColumn="GB" />
              <Mapping SourceColumn="GC" DataSetColumn="GC" />
              <Mapping SourceColumn="H3" DataSetColumn="H3" />
              <Mapping SourceColumn="H4" DataSetColumn="H4" />
              <Mapping SourceColumn="HC" DataSetColumn="HC" />
            </Mappings>
            <Sources />
          </TableAdapter>
        </Tables>
        <Sources />
      </DataSource>
    </xs:appinfo>
  </xs:annotation>
  <xs:element name="dsSMSMonthly" msdata:IsDataSet="true" msdata:UseCurrentLocale="true" msprop:EnableTableAdapterManager="true" msprop:Generator_DataSetName="dsSMSMonthly" msprop:Generator_UserDSName="dsSMSMonthly">
    <xs:complexType>
      <xs:choice minOccurs="0" maxOccurs="unbounded">
        <xs:element name="ReportSMSMonthly" msprop:Generator_TableClassName="ReportSMSMonthlyDataTable" msprop:Generator_TableVarName="tableReportSMSMonthly" msprop:Generator_TablePropName="ReportSMSMonthly" msprop:Generator_RowDeletingName="ReportSMSMonthlyRowDeleting" msprop:Generator_RowChangingName="ReportSMSMonthlyRowChanging" msprop:Generator_RowEvHandlerName="ReportSMSMonthlyRowChangeEventHandler" msprop:Generator_RowDeletedName="ReportSMSMonthlyRowDeleted" msprop:Generator_UserTableName="ReportSMSMonthly" msprop:Generator_RowChangedName="ReportSMSMonthlyRowChanged" msprop:Generator_RowEvArgName="ReportSMSMonthlyRowChangeEvent" msprop:Generator_RowClassName="ReportSMSMonthlyRow">
          <xs:complexType>
            <xs:sequence>
              <xs:element name="STT" msprop:Generator_ColumnVarNameInTable="columnSTT" msprop:Generator_ColumnPropNameInRow="STT" msprop:Generator_ColumnPropNameInTable="STTColumn" msprop:Generator_UserColumnName="STT" type="xs:int" minOccurs="0" />
              <xs:element name="Code" msprop:Generator_ColumnVarNameInTable="columnCode" msprop:Generator_ColumnPropNameInRow="Code" msprop:Generator_ColumnPropNameInTable="CodeColumn" msprop:Generator_UserColumnName="Code" type="xs:int" minOccurs="0" />
              <xs:element name="CodeNS" msprop:Generator_ColumnVarNameInTable="columnCodeNS" msprop:Generator_ColumnPropNameInRow="CodeNS" msprop:Generator_ColumnPropNameInTable="CodeNSColumn" msprop:Generator_UserColumnName="CodeNS" minOccurs="0">
                <xs:simpleType>
                  <xs:restriction base="xs:string">
                    <xs:maxLength value="20" />
                  </xs:restriction>
                </xs:simpleType>
              </xs:element>
              <xs:element name="Name" msprop:Generator_ColumnVarNameInTable="columnName" msprop:Generator_ColumnPropNameInRow="Name" msprop:Generator_ColumnPropNameInTable="NameColumn" msprop:Generator_UserColumnName="Name" minOccurs="0">
                <xs:simpleType>
                  <xs:restriction base="xs:string">
                    <xs:maxLength value="200" />
                  </xs:restriction>
                </xs:simpleType>
              </xs:element>
              <xs:element name="BAGroup" msprop:Generator_ColumnVarNameInTable="columnBAGroup" msprop:Generator_ColumnPropNameInRow="BAGroup" msprop:Generator_ColumnPropNameInTable="BAGroupColumn" msprop:Generator_UserColumnName="BAGroup" minOccurs="0">
                <xs:simpleType>
                  <xs:restriction base="xs:string">
                    <xs:maxLength value="50" />
                  </xs:restriction>
                </xs:simpleType>
              </xs:element>
              <xs:element name="Phone" msprop:Generator_ColumnVarNameInTable="columnPhone" msprop:Generator_ColumnPropNameInRow="Phone" msprop:Generator_ColumnPropNameInTable="PhoneColumn" msprop:Generator_UserColumnName="Phone" minOccurs="0">
                <xs:simpleType>
                  <xs:restriction base="xs:string">
                    <xs:maxLength value="20" />
                  </xs:restriction>
                </xs:simpleType>
              </xs:element>
              <xs:element name="BASCode" msprop:Generator_ColumnVarNameInTable="columnBASCode" msprop:Generator_ColumnPropNameInRow="BASCode" msprop:Generator_ColumnPropNameInTable="BASCodeColumn" msprop:Generator_UserColumnName="BASCode" minOccurs="0">
                <xs:simpleType>
                  <xs:restriction base="xs:string">
                    <xs:maxLength value="20" />
                  </xs:restriction>
                </xs:simpleType>
              </xs:element>
              <xs:element name="BASName" msprop:Generator_ColumnVarNameInTable="columnBASName" msprop:Generator_ColumnPropNameInRow="BASName" msprop:Generator_ColumnPropNameInTable="BASNameColumn" msprop:Generator_UserColumnName="BASName" minOccurs="0">
                <xs:simpleType>
                  <xs:restriction base="xs:string">
                    <xs:maxLength value="200" />
                  </xs:restriction>
                </xs:simpleType>
              </xs:element>
              <xs:element name="ProfileStatus" msprop:Generator_ColumnVarNameInTable="columnProfileStatus" msprop:Generator_ColumnPropNameInRow="ProfileStatus" msprop:Generator_ColumnPropNameInTable="ProfileStatusColumn" msprop:Generator_UserColumnName="ProfileStatus" minOccurs="0">
                <xs:simpleType>
                  <xs:restriction base="xs:string">
                    <xs:maxLength value="50" />
                  </xs:restriction>
                </xs:simpleType>
              </xs:element>
              <xs:element name="TaxCode" msprop:Generator_ColumnVarNameInTable="columnTaxCode" msprop:Generator_ColumnPropNameInRow="TaxCode" msprop:Generator_ColumnPropNameInTable="TaxCodeColumn" msprop:Generator_UserColumnName="TaxCode" minOccurs="0">
                <xs:simpleType>
                  <xs:restriction base="xs:string">
                    <xs:maxLength value="50" />
                  </xs:restriction>
                </xs:simpleType>
              </xs:element>
              <xs:element name="DOB" msprop:Generator_ColumnVarNameInTable="columnDOB" msprop:Generator_ColumnPropNameInRow="DOB" msprop:Generator_ColumnPropNameInTable="DOBColumn" msprop:Generator_UserColumnName="DOB" type="xs:dateTime" minOccurs="0" />
              <xs:element name="DOBD" msprop:Generator_ColumnVarNameInTable="columnDOBD" msprop:Generator_ColumnPropNameInRow="DOBD" msprop:Generator_ColumnPropNameInTable="DOBDColumn" msprop:Generator_UserColumnName="DOBD" type="xs:int" minOccurs="0" />
              <xs:element name="DOBM" msprop:Generator_ColumnVarNameInTable="columnDOBM" msprop:Generator_ColumnPropNameInRow="DOBM" msprop:Generator_ColumnPropNameInTable="DOBMColumn" msprop:Generator_UserColumnName="DOBM" type="xs:int" minOccurs="0" />
              <xs:element name="DOBY" msprop:Generator_ColumnVarNameInTable="columnDOBY" msprop:Generator_ColumnPropNameInRow="DOBY" msprop:Generator_ColumnPropNameInTable="DOBYColumn" msprop:Generator_UserColumnName="DOBY" type="xs:int" minOccurs="0" />
              <xs:element name="Folk" msprop:Generator_ColumnVarNameInTable="columnFolk" msprop:Generator_ColumnPropNameInRow="Folk" msprop:Generator_ColumnPropNameInTable="FolkColumn" msprop:Generator_UserColumnName="Folk" minOccurs="0">
                <xs:simpleType>
                  <xs:restriction base="xs:string">
                    <xs:maxLength value="50" />
                  </xs:restriction>
                </xs:simpleType>
              </xs:element>
              <xs:element name="Nationality" msprop:Generator_ColumnVarNameInTable="columnNationality" msprop:Generator_ColumnPropNameInRow="Nationality" msprop:Generator_ColumnPropNameInTable="NationalityColumn" msprop:Generator_UserColumnName="Nationality" minOccurs="0">
                <xs:simpleType>
                  <xs:restriction base="xs:string">
                    <xs:maxLength value="50" />
                  </xs:restriction>
                </xs:simpleType>
              </xs:element>
              <xs:element name="ResidentAddress" msprop:Generator_ColumnVarNameInTable="columnResidentAddress" msprop:Generator_ColumnPropNameInRow="ResidentAddress" msprop:Generator_ColumnPropNameInTable="ResidentAddressColumn" msprop:Generator_UserColumnName="ResidentAddress" minOccurs="0">
                <xs:simpleType>
                  <xs:restriction base="xs:string">
                    <xs:maxLength value="200" />
                  </xs:restriction>
                </xs:simpleType>
              </xs:element>
              <xs:element name="IDCard" msprop:Generator_ColumnVarNameInTable="columnIDCard" msprop:Generator_ColumnPropNameInRow="IDCard" msprop:Generator_ColumnPropNameInTable="IDCardColumn" msprop:Generator_UserColumnName="IDCard" minOccurs="0">
                <xs:simpleType>
                  <xs:restriction base="xs:string">
                    <xs:maxLength value="20" />
                  </xs:restriction>
                </xs:simpleType>
              </xs:element>
              <xs:element name="IDDate" msprop:Generator_ColumnVarNameInTable="columnIDDate" msprop:Generator_ColumnPropNameInRow="IDDate" msprop:Generator_ColumnPropNameInTable="IDDateColumn" msprop:Generator_UserColumnName="IDDate" type="xs:dateTime" minOccurs="0" />
              <xs:element name="IDDateD" msprop:Generator_ColumnVarNameInTable="columnIDDateD" msprop:Generator_ColumnPropNameInRow="IDDateD" msprop:Generator_ColumnPropNameInTable="IDDateDColumn" msprop:Generator_UserColumnName="IDDateD" type="xs:int" minOccurs="0" />
              <xs:element name="IDDateM" msprop:Generator_ColumnVarNameInTable="columnIDDateM" msprop:Generator_ColumnPropNameInRow="IDDateM" msprop:Generator_ColumnPropNameInTable="IDDateMColumn" msprop:Generator_UserColumnName="IDDateM" type="xs:int" minOccurs="0" />
              <xs:element name="IDDateY" msprop:Generator_ColumnVarNameInTable="columnIDDateY" msprop:Generator_ColumnPropNameInRow="IDDateY" msprop:Generator_ColumnPropNameInTable="IDDateYColumn" msprop:Generator_UserColumnName="IDDateY" type="xs:int" minOccurs="0" />
              <xs:element name="IDProvideBy" msprop:Generator_ColumnVarNameInTable="columnIDProvideBy" msprop:Generator_ColumnPropNameInRow="IDProvideBy" msprop:Generator_ColumnPropNameInTable="IDProvideByColumn" msprop:Generator_UserColumnName="IDProvideBy" minOccurs="0">
                <xs:simpleType>
                  <xs:restriction base="xs:string">
                    <xs:maxLength value="200" />
                  </xs:restriction>
                </xs:simpleType>
              </xs:element>
              <xs:element name="BAStatus" msprop:Generator_ColumnVarNameInTable="columnBAStatus" msprop:Generator_ColumnPropNameInRow="BAStatus" msprop:Generator_ColumnPropNameInTable="BAStatusColumn" msprop:Generator_UserColumnName="BAStatus" minOccurs="0">
                <xs:simpleType>
                  <xs:restriction base="xs:string">
                    <xs:maxLength value="50" />
                  </xs:restriction>
                </xs:simpleType>
              </xs:element>
              <xs:element name="InDate" msprop:Generator_ColumnVarNameInTable="columnInDate" msprop:Generator_ColumnPropNameInRow="InDate" msprop:Generator_ColumnPropNameInTable="InDateColumn" msprop:Generator_UserColumnName="InDate" type="xs:dateTime" minOccurs="0" />
              <xs:element name="InDateD" msprop:Generator_ColumnVarNameInTable="columnInDateD" msprop:Generator_ColumnPropNameInRow="InDateD" msprop:Generator_ColumnPropNameInTable="InDateDColumn" msprop:Generator_UserColumnName="InDateD" type="xs:int" minOccurs="0" />
              <xs:element name="InDateM" msprop:Generator_ColumnVarNameInTable="columnInDateM" msprop:Generator_ColumnPropNameInRow="InDateM" msprop:Generator_ColumnPropNameInTable="InDateMColumn" msprop:Generator_UserColumnName="InDateM" type="xs:int" minOccurs="0" />
              <xs:element name="InDateY" msprop:Generator_ColumnVarNameInTable="columnInDateY" msprop:Generator_ColumnPropNameInRow="InDateY" msprop:Generator_ColumnPropNameInTable="InDateYColumn" msprop:Generator_UserColumnName="InDateY" type="xs:int" minOccurs="0" />
              <xs:element name="OutDate" msprop:Generator_ColumnVarNameInTable="columnOutDate" msprop:Generator_ColumnPropNameInRow="OutDate" msprop:Generator_ColumnPropNameInTable="OutDateColumn" msprop:Generator_UserColumnName="OutDate" type="xs:dateTime" minOccurs="0" />
              <xs:element name="OutDateD" msprop:Generator_ColumnVarNameInTable="columnOutDateD" msprop:Generator_ColumnPropNameInRow="OutDateD" msprop:Generator_ColumnPropNameInTable="OutDateDColumn" msprop:Generator_UserColumnName="OutDateD" type="xs:int" minOccurs="0" />
              <xs:element name="OutDateM" msprop:Generator_ColumnVarNameInTable="columnOutDateM" msprop:Generator_ColumnPropNameInRow="OutDateM" msprop:Generator_ColumnPropNameInTable="OutDateMColumn" msprop:Generator_UserColumnName="OutDateM" type="xs:int" minOccurs="0" />
              <xs:element name="OutDateY" msprop:Generator_ColumnVarNameInTable="columnOutDateY" msprop:Generator_ColumnPropNameInRow="OutDateY" msprop:Generator_ColumnPropNameInTable="OutDateYColumn" msprop:Generator_UserColumnName="OutDateY" type="xs:int" minOccurs="0" />
              <xs:element name="StartContractDate" msprop:Generator_ColumnVarNameInTable="columnStartContractDate" msprop:Generator_ColumnPropNameInRow="StartContractDate" msprop:Generator_ColumnPropNameInTable="StartContractDateColumn" msprop:Generator_UserColumnName="StartContractDate" type="xs:dateTime" minOccurs="0" />
              <xs:element name="StartCDateD" msprop:Generator_ColumnVarNameInTable="columnStartCDateD" msprop:Generator_ColumnPropNameInRow="StartCDateD" msprop:Generator_ColumnPropNameInTable="StartCDateDColumn" msprop:Generator_UserColumnName="StartCDateD" type="xs:int" minOccurs="0" />
              <xs:element name="StartCDateM" msprop:Generator_ColumnVarNameInTable="columnStartCDateM" msprop:Generator_ColumnPropNameInRow="StartCDateM" msprop:Generator_ColumnPropNameInTable="StartCDateMColumn" msprop:Generator_UserColumnName="StartCDateM" type="xs:int" minOccurs="0" />
              <xs:element name="StartCDateY" msprop:Generator_ColumnVarNameInTable="columnStartCDateY" msprop:Generator_ColumnPropNameInRow="StartCDateY" msprop:Generator_ColumnPropNameInTable="StartCDateYColumn" msprop:Generator_UserColumnName="StartCDateY" minOccurs="0">
                <xs:simpleType>
                  <xs:restriction base="xs:string">
                    <xs:maxLength value="10" />
                  </xs:restriction>
                </xs:simpleType>
              </xs:element>
              <xs:element name="EndContractDate" msprop:Generator_ColumnVarNameInTable="columnEndContractDate" msprop:Generator_ColumnPropNameInRow="EndContractDate" msprop:Generator_ColumnPropNameInTable="EndContractDateColumn" msprop:Generator_UserColumnName="EndContractDate" type="xs:dateTime" minOccurs="0" />
              <xs:element name="EndCDateD" msprop:Generator_ColumnVarNameInTable="columnEndCDateD" msprop:Generator_ColumnPropNameInRow="EndCDateD" msprop:Generator_ColumnPropNameInTable="EndCDateDColumn" msprop:Generator_UserColumnName="EndCDateD" type="xs:int" minOccurs="0" />
              <xs:element name="EndCDateM" msprop:Generator_ColumnVarNameInTable="columnEndCDateM" msprop:Generator_ColumnPropNameInRow="EndCDateM" msprop:Generator_ColumnPropNameInTable="EndCDateMColumn" msprop:Generator_UserColumnName="EndCDateM" type="xs:int" minOccurs="0" />
              <xs:element name="EndCDateY" msprop:Generator_ColumnVarNameInTable="columnEndCDateY" msprop:Generator_ColumnPropNameInRow="EndCDateY" msprop:Generator_ColumnPropNameInTable="EndCDateYColumn" msprop:Generator_UserColumnName="EndCDateY" type="xs:int" minOccurs="0" />
              <xs:element name="ContractType" msprop:Generator_ColumnVarNameInTable="columnContractType" msprop:Generator_ColumnPropNameInRow="ContractType" msprop:Generator_ColumnPropNameInTable="ContractTypeColumn" msprop:Generator_UserColumnName="ContractType" minOccurs="0">
                <xs:simpleType>
                  <xs:restriction base="xs:string">
                    <xs:maxLength value="50" />
                  </xs:restriction>
                </xs:simpleType>
              </xs:element>
              <xs:element name="AccountNumber" msprop:Generator_ColumnVarNameInTable="columnAccountNumber" msprop:Generator_ColumnPropNameInRow="AccountNumber" msprop:Generator_ColumnPropNameInTable="AccountNumberColumn" msprop:Generator_UserColumnName="AccountNumber" minOccurs="0">
                <xs:simpleType>
                  <xs:restriction base="xs:string">
                    <xs:maxLength value="20" />
                  </xs:restriction>
                </xs:simpleType>
              </xs:element>
              <xs:element name="Bank" msprop:Generator_ColumnVarNameInTable="columnBank" msprop:Generator_ColumnPropNameInRow="Bank" msprop:Generator_ColumnPropNameInTable="BankColumn" msprop:Generator_UserColumnName="Bank" minOccurs="0">
                <xs:simpleType>
                  <xs:restriction base="xs:string">
                    <xs:maxLength value="50" />
                  </xs:restriction>
                </xs:simpleType>
              </xs:element>
              <xs:element name="OutletSMSCode" msprop:Generator_ColumnVarNameInTable="columnOutletSMSCode" msprop:Generator_ColumnPropNameInRow="OutletSMSCode" msprop:Generator_ColumnPropNameInTable="OutletSMSCodeColumn" msprop:Generator_UserColumnName="OutletSMSCode" minOccurs="0">
                <xs:simpleType>
                  <xs:restriction base="xs:string">
                    <xs:maxLength value="20" />
                  </xs:restriction>
                </xs:simpleType>
              </xs:element>
              <xs:element name="OutletDragonCode" msprop:Generator_ColumnVarNameInTable="columnOutletDragonCode" msprop:Generator_ColumnPropNameInRow="OutletDragonCode" msprop:Generator_ColumnPropNameInTable="OutletDragonCodeColumn" msprop:Generator_UserColumnName="OutletDragonCode" minOccurs="0">
                <xs:simpleType>
                  <xs:restriction base="xs:string">
                    <xs:maxLength value="20" />
                  </xs:restriction>
                </xs:simpleType>
              </xs:element>
              <xs:element name="Brand" msprop:Generator_ColumnVarNameInTable="columnBrand" msprop:Generator_ColumnPropNameInRow="Brand" msprop:Generator_ColumnPropNameInTable="BrandColumn" msprop:Generator_UserColumnName="Brand" minOccurs="0">
                <xs:simpleType>
                  <xs:restriction base="xs:string">
                    <xs:maxLength value="50" />
                  </xs:restriction>
                </xs:simpleType>
              </xs:element>
              <xs:element name="OutletName" msprop:Generator_ColumnVarNameInTable="columnOutletName" msprop:Generator_ColumnPropNameInRow="OutletName" msprop:Generator_ColumnPropNameInTable="OutletNameColumn" msprop:Generator_UserColumnName="OutletName" minOccurs="0">
                <xs:simpleType>
                  <xs:restriction base="xs:string">
                    <xs:maxLength value="200" />
                  </xs:restriction>
                </xs:simpleType>
              </xs:element>
              <xs:element name="OutletAddress" msprop:Generator_ColumnVarNameInTable="columnOutletAddress" msprop:Generator_ColumnPropNameInRow="OutletAddress" msprop:Generator_ColumnPropNameInTable="OutletAddressColumn" msprop:Generator_UserColumnName="OutletAddress" minOccurs="0">
                <xs:simpleType>
                  <xs:restriction base="xs:string">
                    <xs:maxLength value="200" />
                  </xs:restriction>
                </xs:simpleType>
              </xs:element>
              <xs:element name="Location" msprop:Generator_ColumnVarNameInTable="columnLocation" msprop:Generator_ColumnPropNameInRow="Location" msprop:Generator_ColumnPropNameInTable="LocationColumn" msprop:Generator_UserColumnName="Location" minOccurs="0">
                <xs:simpleType>
                  <xs:restriction base="xs:string">
                    <xs:maxLength value="50" />
                  </xs:restriction>
                </xs:simpleType>
              </xs:element>
              <xs:element name="Province" msprop:Generator_ColumnVarNameInTable="columnProvince" msprop:Generator_ColumnPropNameInRow="Province" msprop:Generator_ColumnPropNameInTable="ProvinceColumn" msprop:Generator_UserColumnName="Province" minOccurs="0">
                <xs:simpleType>
                  <xs:restriction base="xs:string">
                    <xs:maxLength value="50" />
                  </xs:restriction>
                </xs:simpleType>
              </xs:element>
              <xs:element name="CVTCSR" msprop:Generator_ColumnVarNameInTable="columnCVTCSR" msprop:Generator_ColumnPropNameInRow="CVTCSR" msprop:Generator_ColumnPropNameInTable="CVTCSRColumn" msprop:Generator_UserColumnName="CVTCSR" minOccurs="0">
                <xs:simpleType>
                  <xs:restriction base="xs:string">
                    <xs:maxLength value="200" />
                  </xs:restriction>
                </xs:simpleType>
              </xs:element>
              <xs:element name="ASM" msprop:Generator_ColumnVarNameInTable="columnASM" msprop:Generator_ColumnPropNameInRow="ASM" msprop:Generator_ColumnPropNameInTable="ASMColumn" msprop:Generator_UserColumnName="ASM" minOccurs="0">
                <xs:simpleType>
                  <xs:restriction base="xs:string">
                    <xs:maxLength value="200" />
                  </xs:restriction>
                </xs:simpleType>
              </xs:element>
              <xs:element name="WorkingHour" msprop:Generator_ColumnVarNameInTable="columnWorkingHour" msprop:Generator_ColumnPropNameInRow="WorkingHour" msprop:Generator_ColumnPropNameInTable="WorkingHourColumn" msprop:Generator_UserColumnName="WorkingHour" minOccurs="0">
                <xs:simpleType>
                  <xs:restriction base="xs:string">
                    <xs:maxLength value="50" />
                  </xs:restriction>
                </xs:simpleType>
              </xs:element>
              <xs:element name="DayOff" msprop:Generator_ColumnVarNameInTable="columnDayOff" msprop:Generator_ColumnPropNameInRow="DayOff" msprop:Generator_ColumnPropNameInTable="DayOffColumn" msprop:Generator_UserColumnName="DayOff" minOccurs="0">
                <xs:simpleType>
                  <xs:restriction base="xs:string">
                    <xs:maxLength value="50" />
                  </xs:restriction>
                </xs:simpleType>
              </xs:element>
              <xs:element name="Note" msprop:Generator_ColumnVarNameInTable="columnNote" msprop:Generator_ColumnPropNameInRow="Note" msprop:Generator_ColumnPropNameInTable="NoteColumn" msprop:Generator_UserColumnName="Note" minOccurs="0">
                <xs:simpleType>
                  <xs:restriction base="xs:string">
                    <xs:maxLength value="2147483647" />
                  </xs:restriction>
                </xs:simpleType>
              </xs:element>
              <xs:element name="NoOfDay" msprop:Generator_ColumnVarNameInTable="columnNoOfDay" msprop:Generator_ColumnPropNameInRow="NoOfDay" msprop:Generator_ColumnPropNameInTable="NoOfDayColumn" msprop:Generator_UserColumnName="NoOfDay" type="xs:int" minOccurs="0" />
              <xs:element name="CB" msprop:Generator_ColumnVarNameInTable="columnCB" msprop:Generator_ColumnPropNameInRow="CB" msprop:Generator_ColumnPropNameInTable="CBColumn" msprop:Generator_UserColumnName="CB" type="xs:int" minOccurs="0" />
              <xs:element name="CC" msprop:Generator_ColumnVarNameInTable="columnCC" msprop:Generator_ColumnPropNameInRow="CC" msprop:Generator_ColumnPropNameInTable="CCColumn" msprop:Generator_UserColumnName="CC" type="xs:int" minOccurs="0" />
              <xs:element name="CD" msprop:Generator_ColumnVarNameInTable="columnCD" msprop:Generator_ColumnPropNameInRow="CD" msprop:Generator_ColumnPropNameInTable="CDColumn" msprop:Generator_UserColumnName="CD" type="xs:int" minOccurs="0" />
              <xs:element name="D4" msprop:Generator_ColumnVarNameInTable="columnD4" msprop:Generator_ColumnPropNameInRow="D4" msprop:Generator_ColumnPropNameInTable="D4Column" msprop:Generator_UserColumnName="D4" type="xs:int" minOccurs="0" />
              <xs:element name="DC" msprop:Generator_ColumnVarNameInTable="columnDC" msprop:Generator_ColumnPropNameInRow="DC" msprop:Generator_ColumnPropNameInTable="DCColumn" msprop:Generator_UserColumnName="DC" type="xs:int" minOccurs="0" />
              <xs:element name="GB" msprop:Generator_ColumnVarNameInTable="columnGB" msprop:Generator_ColumnPropNameInRow="GB" msprop:Generator_ColumnPropNameInTable="GBColumn" msprop:Generator_UserColumnName="GB" type="xs:int" minOccurs="0" />
              <xs:element name="GC" msprop:Generator_ColumnVarNameInTable="columnGC" msprop:Generator_ColumnPropNameInRow="GC" msprop:Generator_ColumnPropNameInTable="GCColumn" msprop:Generator_UserColumnName="GC" type="xs:int" minOccurs="0" />
              <xs:element name="H3" msprop:Generator_ColumnVarNameInTable="columnH3" msprop:Generator_ColumnPropNameInRow="H3" msprop:Generator_ColumnPropNameInTable="H3Column" msprop:Generator_UserColumnName="H3" type="xs:int" minOccurs="0" />
              <xs:element name="H4" msprop:Generator_ColumnVarNameInTable="columnH4" msprop:Generator_ColumnPropNameInRow="H4" msprop:Generator_ColumnPropNameInTable="H4Column" msprop:Generator_UserColumnName="H4" type="xs:int" minOccurs="0" />
              <xs:element name="HC" msprop:Generator_ColumnVarNameInTable="columnHC" msprop:Generator_ColumnPropNameInRow="HC" msprop:Generator_ColumnPropNameInTable="HCColumn" msprop:Generator_UserColumnName="HC" type="xs:int" minOccurs="0" />
            </xs:sequence>
          </xs:complexType>
        </xs:element>
      </xs:choice>
    </xs:complexType>
  </xs:element>
</xs:schema>